package com.atguigu.gmallpublisher.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface SugarMapper {
    @Select("select keyword from dws_traffic_keyword_page_view_window where toYYYYMMDD(stt)=#{date} " +
            "group by keyword order by keyword_count desc limit #{limit}")
    List<Map> selectKeyWord(@Param("date") int date, @Param("limit") int limit);
}
